Hệ thống quản lý trường đại học bằng PHP
1 <?php
2 require_once('../includes/config.php');
3 if(!$user->is_logged_in()){
4 header('Location: ../login.php');
5 }
6 ?>
7 <!DOCTYPE html>
8 <html>
9 <head>
10 <meta charset="utf-8">
11 <meta name="viewport" content="width=device-width, initial-scale=1">
12 <title>Documents Edit</title>
13
14 <link href="css/bootstrap.min.css" rel="stylesheet">
15 <link href="css/datepicker3.css" rel="stylesheet">
16 <link href="css/bootstrap-table.css" rel="stylesheet">
17 <link href="css/styles.css" rel="stylesheet">
18
19 <!--Icons-->
20 <script src="js/lumino.glyphs.js"></script>
21
22 <!--[if lt IE 9]>
23 <script src="js/html5shiv.js"></script>
24 <script src="js/respond.min.js"></script>
25 <![endif]-->
26
27 </head>
28
29 <body>
30 <?php
31 require_once('includes/common.php');
32 ?>
33
34 <div class="col-sm-9 col-sm-offset-3 col-lg-10 col-lg-offset-2 main">
35 <div class="row">
36 <ol class="breadcrumb">
37 </ol>
38 </div><!--/.row-->
39 <div class="row">
40 <div class="col-lg-12">
41
42
43 <div class="panel panel-default">
44 <div class="panel-heading">Documents List</div>
45 <div class="panel-body">
46 <table data-toggle="table" data-show-refresh="true" data-show-toggle="true" data-show-columns="true" data-search="true" data-select-item-name="toolbar1" data-pagination="true" data-sort-name="name" data-sort-order="desc">
47 <thead>
48 <tr>
49 <th data-sortable="true">ID</th>
50 <th ddata-sortable="true">Title</th>
51 <th ddata-sortable="true">Author</th>
52 <th ddata-sortable="true">Fillière</th>
53 <th ddata-sortable="true">type</th>
54 <th ddata-sortable="true">Date</th>
55 </tr>
56 </thead>
57 <tbody>
58 <?php
59 try {
60 $stmt = $db->query('SELECT *
61 FROM documents
62 INNER JOIN niveau ON documents.lvlID = niveau.lvlID
63 INNER JOIN filierefullinfo ON filierefullinfo.filiereID = niveau.filiereID
64 INNER JOIN matiere ON matiere.matiereID = documents.matiereID ;');
65 while($row = $stmt->fetch()){
66 echo "<tr><td>".$row['documentID']."</td><td>".$row['nom']."</td><td>".$row['author'].'</td><td>'.$row['full_name'].'</td><td>'.$row['type'].'</td><td>'.$row['date'].'</td></tr>';
67 }
68 }catch(PDOException $e) {
69 echo $e->getMessage();
70 }
71 ?>
72
73 </tbody>
74 </table>
75 </div>
76 </div>
77 <div class="panel panel-default">
78 <div class="panel-heading">add a Document</div>
79 <div class="panel-body">
80 <form role="form" action="actions/document.php" method="POST" enctype="multipart/form-data">
81 <div class="form-group">
82 <label>title</label>
83 <input class="form-control" name="title" >
84 </div>
85 <div class="form-group">
86 <label>Author</label>
87 <input class="form-control" name="author" >
88 </div>
89 <div class="form-group">
90 <label>Niveau</label>
91 <input class="form-control" name="niveau" >
92 </div>
93 <div class="form-group">
94 <label>Fillière</label>
95 <select class="form-control" name="filliere">
96 <option value="1">Génie Logiciel</option>
97 <option value="2">Informatique Industrielle et Automatique</option>
98 <option value="3">Réseaux Informatiques et Télécommunications</option>
99 <option value="4">Instrumentation et Maintenance Industrielle</option>
100 <option value="5">Chimie Industrielle</option>
101 <option value="6">Biologie industrielle</option>
102 <option value="7">Tronc Commun MPI</option>
103 <option value="8">Tronc Commun CBA</option>
104 </select>
105 </div>
106 <div class="form-group">
107 <label>Matière</label>
108 <select class="form-control" name="matiereID">
109 <?php
110 $stmt = $db->query('SELECT * FROM matiere') ;
111 while($row = $stmt->fetch()){
112 echo '<option value="'.$row['matiereID'].'">'.$row['nom_matiere'].'</option>';
113 }
114 ?>
115 </select>
116 </div>
117 <div class="form-group">
118 <label>type</label>
119 <input class="form-control" name="type" >
120 </div>
121 <div class="form-group">
122 <label class="control-label">Select File</label>
123 <input id="input-1a" type="file" class="file" data-show-preview="false" name="fileToUpload">
124 </div>
125 <button type="submit" name="submit" class="btn btn-primary">Submit Button</button>
126 <button type="reset" class="btn btn-default">Reset Button</button>
127 </div>
128 </form>
129 </div>
130 </div>
131 </div>
132 </div><!--/.row-->
133 </div><!--/.main-->
134
135 <script src="js/jquery-1.11.1.min.js"></script>
136 <script src="js/bootstrap.min.js"></script>
137 <script src="js/chart.min.js"></script>
138 <script src="js/chart-data.js"></script>
139 <script src="js/easypiechart.js"></script>
140 <script src="js/easypiechart-data.js"></script>
141 <script src="js/bootstrap-datepicker.js"></script>
142 <script src="js/bootstrap-table.js"></script>
143 <script>
144 !function ($) {
145 $(document).on("click","ul.nav li.parent > a > span.icon", function(){
146 $(this).find('em:first').toggleClass("glyphicon-minus");
147 });
148 $(".sidebar span.icon").find('em:first').addClass("glyphicon-plus");
149 }(window.jQuery);
150
151 $(window).on('resize', function () {
152 if ($(window).width() > 768) $('#sidebar-collapse').collapse('show')
153 })
154 $(window).on('resize', function () {
155 if ($(window).width() <= 767) $('#sidebar-collapse').collapse('hide')
156 })
157 </script>
158 </body>
159
160 </html>